use ClientDW_X

db.PICompanyAssessment.find({Ticker: /:/}).forEach(function(item){
    var split = item.Ticker.split(":")
    db.PICompanyAssessment.update({_id: item._id}, { $set: { 'Ticker': split[1], 'Exchange': split[0]}});
});


db.PICompanyAssessmentShortReport.find({Ticker: /:/}).forEach(function(item){
    var split = item.Ticker.split(":")
    db.PICompanyAssessmentShortReport.update({_id: item._id}, { $set: { 'Ticker': split[1], 'Exchange': split[0]}});
});